<?php
namespace App\Http\Controllers\Business\Admin\Common;

use Auth;
use App\Models\Feedback;
use App\Models\SecondClass;
use App\Models\Province;
use App\Models\City;
use App\Models\District;
use App\Models\BusinessArea;
use App\Models\Shop;
use App\Models\ShopJoinin;
use App\Models\ShopReview;
use App\Models\User;
use App\Models\HotWord;
use Exception;
use Illuminate\Support\Facades\Redis;


class Common{
    //通过手机获取昵称
    public static function getNicknameByMobile($mobile) {
        if(!$mobile) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $nickname = User::where('mobile', $mobile)->pluck('nickname')->first();
        return ['status'=>'success', 'data'=>$nickname];
    }
    //获取授权城市
    public static function getAuthCity() {
        $user = Auth::guard('adminweb')->user();
        $cityAuthJson = $user->cityauth;
        $cityAuth = json_decode($cityAuthJson, true);
        $lists = [];
        $defaultCityId = '';
        $defaultCityName = '';
        foreach($cityAuth as $key => $val) {
            $city = City::where('id', $key)->first();
            if($city) {
                array_push($lists, ['cityid'=>$key, 'cityname'=>$city->name]);
            }
            if(!$defaultCityId) {
                $defaultCityId = $key; //默认第一个
                $defaultCityName = $city->name;
            }
        }
        $data = [
            'cityid' => $defaultCityId,
            'cityname' => $defaultCityName,
            'lists' => $lists
        ];
        return ['status'=>'success', 'data'=>$data];
    }
    //获取已开通的城市
    public static function getOpenedCity() {
        $data = City::where('status', '1')->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过cityauth
    public static function getAreaByCityAuth($cityAuth) {
        if(empty($cityAuth)) {
           return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        $data = [];
        foreach($cityAuth as $key => $value) {
            $cityName = City::where('id', $key)->pluck('name')->first();
            $districtList = [];
            foreach($value as $districtId) {
                $districtName = District::where('id', $districtId)->pluck('name')->first();
                array_push($districtList, ['id'=>$districtId, 'name'=>$districtName.'|'.$districtId]);
            }
            $list = [
                'id' => $key,
                'name' => $cityName,
                'district' => $districtList
            ];
            array_push($data, $list);
        }
        return ['status'=>'success', 'data'=>$data];
    }
    //搜索
    public static function getSearchString($cityid){
        if(!$cityid) {
            return ['status'=>'failed', 'message'=>'参数错误！'];
        }
        $searcharray = Redis::keys('SearchString:'.$cityid.":*");
        $search = array();
        foreach ($searcharray as $k=>$v) {
            $search[$searcharray[$k]] = Redis::get($searcharray[$k]);
        }
        arsort($search);
        return ['status'=>'success','data'=>$search];
    }
    //热词列表
    public static function hotWordList($cityId) {
        if(!$cityId) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $data = HotWord::where('cityid', $cityId)->select('name', 'sort')->orderBy('sort', 'asc')->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //设立热词
    public static function addHotWord($word, $cityId) {
        if(!$word || !$cityId) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $thisWordCount = HotWord::where('name', $word)->where('cityid', $cityId)->get()->count();
        if($thisWordCount > 0) {
            return ['status'=>'failed', 'message'=>'该词已经是热词'];
        }
        $total = HotWord::where('cityid', $cityId)->get()->count();
        if($total>=10) {
            return ['status'=>'failed', 'message'=>'热词的数量已超过最多次数'];
        }
        $hotWord = HotWord::create([
            'name' => $word,
            'sort' => 1,
            'cityid' => $cityId,
            'adminid' => Auth::guard('adminweb')->id(),
        ]);
        $hotWord->save();
        //修改所有热词的排序
        HotWord::where('cityid', $cityId)->where('name', '<>', $word)->increment('sort', 1);
        return ['status'=>'success', 'message'=>'参数错误'];
    }
    //删除热词
    public static function deleteHotWord($word, $cityId) {
        if(!$word || !$cityId) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $sort = HotWord::where('name', $word)->where('cityid', $cityId)->pluck('sort')->first();
        if($sort) {
            HotWord::where('sort', '>', $sort)->decrement('sort', 1);
        }
        HotWord::where('name', $word)->where('cityid', $cityId)->delete();
        return ['status'=>'success', 'message'=>'删除成功'];
    }
    //修改热词排序, type 为up（上移）down（下移）
    public static function updateHotWordSort($word, $cityId,$currentSort, $type, $step=1) {
        if(!$word||!$cityId||!$type||!$step || !$currentSort) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        if($type == 'up') {
            //上移
            if($currentSort == 1) {
                return ['status'=>'failed', 'message'=>'排序已是第一个'];
            }
            HotWord::where('cityid', $cityId)->where('name', $word)->decrement('sort', $step);
            HotWord::where('cityid', $cityId)->where('name', '<>', $word)->where('sort', ($currentSort-1))->increment('sort', $step);
        } elseif($type == 'down') {
            if($currentSort == 10) {
                return ['status'=>'failed', 'message'=>'排序已是最后一个了'];
            }
            HotWord::where('cityid', $cityId)->where('name', $word)->increment('sort', $step);
            HotWord::where('cityid', $cityId)->where('name', '<>', $word)->where('sort', ($currentSort+1))->decrement('sort', $step);
        } else {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        return ['status'=>'success', 'message'=>'修改成功'];
    }
    //用户反馈,商家反馈 type 为user，shop
    public static function feedback($type,$cityId='') {
        if($type == 'user'){
            $data = Feedback::where('type',$type)->where('cityid',$cityId)->orderBy('created_at','desc')->get();
        }elseif($type == 'shop'){
            $data = Feedback::where('feedback.type',$type)
                ->where('shops.cityid',$cityId)
                ->join('shops','shops.id','=','feedback.shopid')
                ->select('feedback.id','feedback.created_at','feedback.content','feedback.status')
                ->orderBy('feedback.created_at','desc')
                ->get();
        }else{
            return ['status'=>'failed','message'=>'参数错误 '];
        }
        return ['status'=>'success', 'data'=>$data ];
    }
    //导出用户反馈，商家反馈 type 为user,shop
    public static function feedbackManageExport($type,$cityId){
        if(!$cityId || !$type){
            return ['status'=>'failed','message'=>'参数错误 '];
        }
        if($type == 'user'){
            $data = Feedback::where('type',$type)->where('cityid',$cityId)->orderBy('created_at','desc')->get();
        }elseif($type == 'shop'){
            $data = Feedback::where('feedback.type',$type)
                ->where('shops.cityid',$cityId)
                ->join('shops','shops.id','=','feedback.shopid')
                ->select('feedback.id','feedback.created_at','feedback.content','feedback.status')
                ->orderBy('feedback.created_at','desc')
                ->get();
        }else{
            return ['status'=>'failed','message'=>'参数错误 '];
        }
        return ['status'=>'success', 'data'=>$data ];
    }
    public static function getFeedbackDetail($feedbackId) {
        if(!$feedbackId) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $data = Feedback::where('feedback.id', $feedbackId)
            ->join("admin_users", "feedback.adminuserid", "=", "admin_users.id")
            ->select('feedback.id as feedbackid', 'feedback.username', 'feedback.mobile','feedback.content','feedback.status','feedback.note', 'admin_users.realname as adminname', 'admin_users.mobile as adminmobile')
            ->first();
        return ['status'=>'success', 'data'=>$data];
    }
    //编辑反馈
    public static function editFeedback($feedbackId, $status, $note='') {
        if(!$feedbackId || !$status) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $data = [
            'status' => $status,
            'note' => $note,
            'adminuserid' => Auth::guard('adminweb')->id()
        ];
        $result = Feedback::where('id', $feedbackId)->update($data);
        if($result) {
            return ['status'=>'success', 'message'=>'修改成功'];
        } else {
            return ['status'=>'failed', 'message'=>'修改失败'];
        }
    }
    //商家入驻
    public static function shopJoinIn($cityId, $startTime='', $lastTIme='', $page=1, $length=50) {
        if(!$cityId) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        if(!$startTime || !$lastTIme) {
            $startTime = '2016-08-01';
            $lastTIme = date("Y-m-d") . " 23:59:59";
        }
        $skip = ($page-1)*$length;
        if($cityId == 1) {
            $data = ShopJoinin::where('created_at', '>=', $startTime)->where('created_at', '<=', $lastTIme)
                ->select('name', 'sex', 'phone', 'city','created_at')
                ->orderBy('created_at', 'desc')
                ->skip($skip)->take($length)->get();
            foreach($data as $k => $v) {
                $cityId = $data[$k]['city'];
                if($cityId==''||$cityId==0) {
                    $data[$k]['cityname'] = '其他市';
                } else {
                    $data[$k]['cityname'] = City::where('id', $cityId)->pluck('name')->first();
                }
            }
        } else {
            $data = ShopJoinin::where('shop_joinin.created_at', '>=', $startTime)->where('shop_joinin.created_at', '<=', $lastTIme)
                ->where('shop_joinin.city', $cityId)
                ->join('city', 'shop_joinin.city', '=', 'city.id')
                ->select('shop_joinin.name', 'shop_joinin.sex', 'shop_joinin.phone', 'city.name as cityname', 'shop_joinin.created_at')
                ->orderBy('shop_joinin.created_at', 'desc')
                ->skip($skip)->take($length)->get();
        }
        return ['status'=>'success', 'data'=>$data];
    }
    //获取短信验证码
    public static function getSmsCode($mobile, $type) {
        if(!$mobile || !$type) {
            return ['status'=>'failed', 'message'=>'获取失败'];
        }
        if($type == 'user') {
            $code = Redis::get('User:SmsMobile:' . $mobile);
            if(!$code) {
                //语音验证码
                $code = Redis::get('Shop:SalesMan:SmsMobile:'.$mobile);
            }
        } else {
            $code = Redis::get('Shop:SmsMobile:' . $mobile);
            if(!$code) {
                //语音验证码
                $code = Redis::get('Shop:SalesMan:SmsMobile:'.$mobile);
            }
            if(!$code) {
                $code = Redis::get('ShopWeb:SmsMobile:'.$mobile);
            }
        }
        if($code == '') {
            return ['status'=>'failed', 'message'=>'获取失败'];
        } else {
            return ['status'=>'success', 'data'=>['code'=>$code]];
        }
    }
    //通过地址获取经纬度
    public static function getLongitudeAndLatitude($address) {
        if (!$address) {
            return ['status' => 'failed', 'message' => '参数不对！'];
        }
        $address = str_replace('（','(', $address);
        $address = str_replace('）', '(', $address);
        $address = str_replace(' ', '', $address);
        $url = "http://restapi.amap.com/v3/geocode/geo?key=77095839e7a388d0a59f32ae121ea2f5&output=JSON&address=" . $address;
        $content = file_get_contents($url);
        $data = json_decode($content, true);
        if(isset($data['geocodes'][0])) {
            $location = $data['geocodes']['0']['location'];
            $info = explode(',', $location);
            $returnData = [
                'longitude' => $info['0'],
                'latitude' => $info['1']
            ];
            return ['status'=>'success', 'data'=>$returnData];
        } else {
            return ['status'=>'failed', 'message'=>'获取失败'];
        }
    }
    //通过一级分类id获取二级分类
    public static function getSecondClass($firstClassId) {
        
        if(!$firstClassId) {
            return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        $data = SecondClass::where('firstclassid', $firstClassId)->select('id', 'name', 'status')->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //获取已开通的省份
    public static function getProvince() {
        $data = Province::where('status', '1')->select('id', 'name')->get();
        return ['status'=>'success', 'data'=>$data ];
    }
    //通过所有省份
    public static function getAllProvince() {
        $data = Province::all();
        return ['status'=>'success', 'data'=>$data];
    }
    //开通、取消省份
    public static function updateProvince($provinceId, $status) {
        if(!$provinceId || !$status) {
            return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        if($status != '1' && $status != '0') {
            return ['status'=>'failed', 'message'=>'类型不对'];
        }
        $result = Province::where('id', $provinceId)->update(['status'=>$status]);
        if($result) {
            return ['status'=>'success', 'message'=>'修改成功'];
        } else {
            return ['status'=>'failed', 'message'=>'参数失败'];
        }
    }
    //开通、取消城市
    public static function updateCity($cityId, $status) {
        if(!$cityId || !$status) {
            return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        if($status != '1' && $status != '0') {
            return ['status'=>'failed', 'message'=>'类型不对'];
        }
        $result = City::where('id', $cityId)->update(['status'=>$status]);
        if($result) {
            return ['status'=>'success', 'message'=>'修改成功'];
        } else {
            return ['status'=>'failed', 'message'=>'参数失败'];
        }
    }
    //开通、取消区县
    public static function updateDistrict($districtId, $status) {
        if(!$districtId || !$status) {
            return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        if($status != '1' && $status != '0') {
            return ['status'=>'failed', 'message'=>'类型不对'];
        }
        $result = City::where('id', $districtId)->update(['status'=>$status]);
        if($result) {
            return ['status'=>'success', 'message'=>'修改成功'];
        } else {
            return ['status'=>'failed', 'message'=>'参数失败'];
        }
    }
    //通过省份id获取城市
    public static function getCityByProvinceId($provinceId) {
        if(!$provinceId) {
            return ['status'=>'failed', 'message'=>'参数错误！'];
        }
        $data = City::where('provinceid', $provinceId)->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过省份id获取城市
    public static function getCityByProvinceName($provinceName) {
        if(!$provinceName) {
            return ['status'=>'failed', 'message'=>'参数错误！'];
        }
        $provinceId = Province::where('name', $provinceName)->pluck('id')->first();
        if($provinceId) {
            $data = City::where('provinceid', $provinceId)->get();
            return ['status' => 'success', 'data' => $data];
        } else {
            return ['status' => 'failed', 'message'=>'获取失败'];
        }
    }
    //通过城市id获取区县
    public static function getDistrictByCityId($cityId) {
        if(!$cityId) {
            return ['status'=>'failed', 'message'=>'参数错误！'];
        }
        $data = District::where('cityid', $cityId)->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过区县id获取商圈
    public static function getBusinessAreaByDistrictId($districtId) {
        if(!$districtId) {
            return ['status'=>'failed', 'message'=>'参数错误！'];
        }
        $data = BusinessArea::where('districtid', $districtId)->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过省id获取省的名称
    public static function getProvinceNameByProvinceId($provinceId) {
        if(!$provinceId) {
            return ['status'=>'failed', 'message'=>'参数不对'];
        }
        $data = Province::where('id', $provinceId)->pluck('name')->first();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过省id获取省的名称
    public static function getCityNameByCityId($cityId) {
        if(!$cityId) {
            return ['status'=>'failed', 'message'=>'参数不对'];
        }
        $data = City::where('id', $cityId)->pluck('name')->first();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过省id获取省的名称
    public static function getDistrictNameByDistrictId($districtId) {
        if(!$districtId) {
            return ['status'=>'failed', 'message'=>'参数不对'];
        }
        $data = District::where('id', $districtId)->pluck('name')->first();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过省id获取省的名称
    public static function getBusinessAreaNameByBusinessAreaId($businessAreaId) {
        if(!$businessAreaId) {
            return ['status'=>'failed', 'message'=>'参数不对'];
        }
        $data = BusinessArea::where('id', $businessAreaId)->pluck('name')->first();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过省id获取城市列表，通过市id获取区县id，通过区县id获取商圈id
    public static function getArea($type, $id = '', $status=0) {
        if(($type != 'province') && ($type != 'city') && ($type != 'district') && ($type != 'businessarea')) {
            return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        $data = [];
        if($type == 'province') {
            $data = Province::where('status', 1)->select('id', 'name')->get();
        } elseif($type == 'city') {
            if($status == 1) {
                $data = City::where('provinceid', $id)->where('status', 1)->select('id', 'name')->get();
            } else {
                $data = City::where('provinceid', $id)->select('id', 'name')->get();
            }
        } elseif($type == 'district') {
            if($status == 1) {
                $data = District::where('cityid', $id)->where('status', 1)->select('id', 'name')->get();
            } else {
                $data = District::where('cityid', $id)->select('id', 'name')->get();
            }
        } elseif($type == 'businessarea') {
            if($status == 1) {
                $data = BusinessArea::where('districtid', $id)->where('status', 1)->select('id', 'name')->get();
            } else {
                $data = BusinessArea::where('districtid', $id)->select('id', 'name')->get();
            }
        }
        return ['status'=>'success', 'data'=>$data ];
    }
    //验证商家编码是不是唯一
    public static function verifyShopCode($shopCode) {
        if(!$shopCode) {
            return ['status'=>'failed', 'message'=>'参数不对！'];
        }
        $count = Shop::where('code', $shopCode)->get()->count();
        if($count > 0) {
            return ['status'=>'failed', 'message'=>'已存在'];
        } else {
            $shopReviewCount = ShopReview::where('code', $shopCode)->where('status', '!=', 2)->get()->count();
            if($shopReviewCount > 0) {
                return ['status'=>'failed', 'message'=>'已存在'];
            } else {
                return ['status' => 'success', 'message' => '不存在'];
            }
        }
    }
    //通过商家名称获取商家信息
    public static function getShopByShopName($shopName,$cityId) {
        if(!$shopName || !$cityId) {
            return ['status'=>'failed', 'message'=>'参数错误'];
        }
        $data = Shop::where('name', 'like', '%'.$shopName.'%')->where('cityid',$cityId)->where('status',1)->take(10)->get(); //TODO 目前限制十个，以后分页
        return ['status'=>'success', 'data'=>$data];
    }
    //通过城市id获取城市名称
    public static function getCityName($cityIdArray) {
        if(empty($cityIdArray)) {
            return ['status'=>'failed', 'message'=>'参数不对'];
        }
        $data = City::whereIn('id', $cityIdArray)->select('name')->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //通过区县ID获取区县名称
    public static function getDistrictName($districtIdArray) {
        if(empty($districtIdArray)) {
            return ['status'=>'failed', 'message'=>'参数不对'];
        }
        $data = District::whereIn('id', $districtIdArray)->select('name')->get();
        return ['status'=>'success', 'data'=>$data];
    }
    //输入银行卡号获取银行信息
    public static function getBankName($account) {
        if (!$account) {
            return ['status' => 'failed', 'message' => '参数不对！'];
        }
        $bankArray = self::bankArray();
        $str = substr($account, 0, 6);
        if (!isset($bankArray[$str])) {
            return ['status' => 'failed', 'message' => '获取失败'];
        }
        $bankName = $bankArray[$str];
        return ['status' => 'success', 'data' => $bankName];
    }
    //银行卡帐号
    public static function bankArray() {
        return [
            "370246"=>"中国工商银行","370248"=>"中国工商银行","370249"=>"中国工商银行","427010"=>"中国工商银行","427018"=>"中国工商银行",
            "427019"=>"中国工商银行","427020"=>"中国工商银行","427029"=>"中国工商银行","427030"=>"中国工商银行","427039"=>"中国工商银行",
            "370247"=>"中国工商银行","438125"=>"中国工商银行","438126"=>"中国工商银行","451804"=>"中国工商银行","451810"=>"中国工商银行",
            "451811"=>"中国工商银行","458071"=>"中国工商银行","489734"=>"中国工商银行","489735"=>"中国工商银行","489736"=>"中国工商银行",
            "510529"=>"中国工商银行","427062"=>"中国工商银行","524091"=>"中国工商银行","427064"=>"中国工商银行","530970"=>"中国工商银行",
            "530990"=>"中国工商银行","558360"=>"中国工商银行","620200"=>"中国工商银行","620302"=>"中国工商银行","620402"=>"中国工商银行",
            "620403"=>"中国工商银行","620404"=>"中国工商银行","524047"=>"中国工商银行","620406"=>"中国工商银行","620407"=>"中国工商银行",
            "525498"=>"中国工商银行","620409"=>"中国工商银行","620410"=>"中国工商银行","620411"=>"中国工商银行","620412"=>"中国工商银行",
            "620502"=>"中国工商银行","620503"=>"中国工商银行","620405"=>"中国工商银行","620408"=>"中国工商银行","620512"=>"中国工商银行",
            "620602"=>"中国工商银行","620604"=>"中国工商银行","620607"=>"中国工商银行","620611"=>"中国工商银行","620612"=>"中国工商银行",
            "620704"=>"中国工商银行","620706"=>"中国工商银行","620707"=>"中国工商银行","620708"=>"中国工商银行","620709"=>"中国工商银行",
            "620710"=>"中国工商银行","620609"=>"中国工商银行","620712"=>"中国工商银行","620713"=>"中国工商银行","620714"=>"中国工商银行",
            "620802"=>"中国工商银行","620711"=>"中国工商银行","620904"=>"中国工商银行","620905"=>"中国工商银行","621001"=>"中国工商银行",
            "620902"=>"中国工商银行","621103"=>"中国工商银行","621105"=>"中国工商银行","621106"=>"中国工商银行","621107"=>"中国工商银行",
            "621102"=>"中国工商银行","621203"=>"中国工商银行","621204"=>"中国工商银行","621205"=>"中国工商银行","621206"=>"中国工商银行",
            "621207"=>"中国工商银行","621208"=>"中国工商银行","621209"=>"中国工商银行","621210"=>"中国工商银行","621302"=>"中国工商银行",
            "621303"=>"中国工商银行","621202"=>"中国工商银行","621305"=>"中国工商银行","621306"=>"中国工商银行","621307"=>"中国工商银行",
            "621309"=>"中国工商银行","621311"=>"中国工商银行","621313"=>"中国工商银行","621211"=>"中国工商银行","621315"=>"中国工商银行",
            "621304"=>"中国工商银行","621402"=>"中国工商银行","621404"=>"中国工商银行","621405"=>"中国工商银行","621406"=>"中国工商银行",
            "621407"=>"中国工商银行","621408"=>"中国工商银行","621409"=>"中国工商银行","621410"=>"中国工商银行","621502"=>"中国工商银行",
            "621317"=>"中国工商银行","621511"=>"中国工商银行","621602"=>"中国工商银行","621603"=>"中国工商银行","621604"=>"中国工商银行",
            "621605"=>"中国工商银行","621608"=>"中国工商银行","621609"=>"中国工商银行","621610"=>"中国工商银行","621611"=>"中国工商银行",
            "621612"=>"中国工商银行","621613"=>"中国工商银行","621614"=>"中国工商银行","621615"=>"中国工商银行","621616"=>"中国工商银行",
            "621617"=>"中国工商银行","621607"=>"中国工商银行","621606"=>"中国工商银行","621804"=>"中国工商银行","621807"=>"中国工商银行",
            "621813"=>"中国工商银行","621814"=>"中国工商银行","621817"=>"中国工商银行","621901"=>"中国工商银行","621904"=>"中国工商银行",
            "621905"=>"中国工商银行","621906"=>"中国工商银行","621907"=>"中国工商银行","621908"=>"中国工商银行","621909"=>"中国工商银行",
            "621910"=>"中国工商银行","621911"=>"中国工商银行","621912"=>"中国工商银行","621913"=>"中国工商银行","621915"=>"中国工商银行",
            "622002"=>"中国工商银行","621903"=>"中国工商银行","622004"=>"中国工商银行","622005"=>"中国工商银行","622006"=>"中国工商银行",
            "622007"=>"中国工商银行","622008"=>"中国工商银行","622010"=>"中国工商银行","622011"=>"中国工商银行","622012"=>"中国工商银行",
            "621914"=>"中国工商银行","622015"=>"中国工商银行","622016"=>"中国工商银行","622003"=>"中国工商银行","622018"=>"中国工商银行",
            "622019"=>"中国工商银行","622020"=>"中国工商银行","622102"=>"中国工商银行","622103"=>"中国工商银行","622104"=>"中国工商银行",
            "622105"=>"中国工商银行","622013"=>"中国工商银行","622111"=>"中国工商银行","622114"=>"中国工商银行","622200"=>"中国工商银行",
            "622017"=>"中国工商银行","622202"=>"中国工商银行","622203"=>"中国工商银行","622208"=>"中国工商银行","622210"=>"中国工商银行",
            "622211"=>"中国工商银行","622212"=>"中国工商银行","622213"=>"中国工商银行","622214"=>"中国工商银行","622110"=>"中国工商银行",
            "622220"=>"中国工商银行","622223"=>"中国工商银行","622225"=>"中国工商银行","622229"=>"中国工商银行","622230"=>"中国工商银行",
            "622231"=>"中国工商银行","622232"=>"中国工商银行","622233"=>"中国工商银行","622234"=>"中国工商银行","622235"=>"中国工商银行",
            "622237"=>"中国工商银行","622215"=>"中国工商银行","622239"=>"中国工商银行","622240"=>"中国工商银行","622245"=>"中国工商银行",
            "622224"=>"中国工商银行","622303"=>"中国工商银行","622304"=>"中国工商银行","622305"=>"中国工商银行","622306"=>"中国工商银行",
            "622307"=>"中国工商银行","622308"=>"中国工商银行","622309"=>"中国工商银行","622238"=>"中国工商银行","622314"=>"中国工商银行",
            "622315"=>"中国工商银行","622317"=>"中国工商银行","622302"=>"中国工商银行","622402"=>"中国工商银行","622403"=>"中国工商银行",
            "622404"=>"中国工商银行","622313"=>"中国工商银行","622504"=>"中国工商银行","622505"=>"中国工商银行","622509"=>"中国工商银行",
            "622513"=>"中国工商银行","622517"=>"中国工商银行","622502"=>"中国工商银行","622604"=>"中国工商银行","622605"=>"中国工商银行",
            "622606"=>"中国工商银行","622510"=>"中国工商银行","622703"=>"中国工商银行","622715"=>"中国工商银行","622806"=>"中国工商银行",
            "622902"=>"中国工商银行","622903"=>"中国工商银行","622706"=>"中国工商银行","623002"=>"中国工商银行","623006"=>"中国工商银行",
            "623008"=>"中国工商银行","623011"=>"中国工商银行","623012"=>"中国工商银行","622904"=>"中国工商银行","623015"=>"中国工商银行",
            "623100"=>"中国工商银行","623202"=>"中国工商银行","623301"=>"中国工商银行","623400"=>"中国工商银行","623500"=>"中国工商银行",
            "623602"=>"中国工商银行","623803"=>"中国工商银行","623901"=>"中国工商银行","623014"=>"中国工商银行","624100"=>"中国工商银行",
            "624200"=>"中国工商银行","624301"=>"中国工商银行","624402"=>"中国工商银行","623700"=>"中国工商银行","628288"=>"中国工商银行",
            "624000"=>"中国工商银行","628286"=>"中国工商银行","622206"=>"中国工商银行","621225"=>"中国工商银行","526836"=>"中国工商银行",
            "513685"=>"中国工商银行","543098"=>"中国工商银行","458441"=>"中国工商银行","620058"=>"中国工商银行","621281"=>"中国工商银行",
            "622246"=>"中国工商银行","900000"=>"中国工商银行","544210"=>"中国工商银行","548943"=>"中国工商银行","370267"=>"中国工商银行",
            "621558"=>"中国工商银行","621559"=>"中国工商银行","621722"=>"中国工商银行","621723"=>"中国工商银行","620086"=>"中国工商银行",
            "621226"=>"中国工商银行","402791"=>"中国工商银行","427028"=>"中国工商银行","427038"=>"中国工商银行","548259"=>"中国工商银行",
            "356879"=>"中国工商银行","356880"=>"中国工商银行","356881"=>"中国工商银行","356882"=>"中国工商银行","528856"=>"中国工商银行",
            "621618"=>"中国工商银行","620516"=>"中国工商银行","621227"=>"中国工商银行","621721"=>"中国工商银行","900010"=>"中国工商银行",
            "625330"=>"中国工商银行","625331"=>"中国工商银行","625332"=>"中国工商银行","623062"=>"中国工商银行","622236"=>"中国工商银行",
            "621670"=>"中国工商银行","524374"=>"中国工商银行","550213"=>"中国工商银行","374738"=>"中国工商银行","374739"=>"中国工商银行",
            "621288"=>"中国工商银行","625708"=>"中国工商银行","625709"=>"中国工商银行","622597"=>"中国工商银行","622599"=>"中国工商银行",
            "360883"=>"中国工商银行","360884"=>"中国工商银行","625865"=>"中国工商银行","625866"=>"中国工商银行","625899"=>"中国工商银行",
            "621376"=>"中国工商银行","620054"=>"中国工商银行","620142"=>"中国工商银行","621423"=>"中国工商银行","625927"=>"中国工商银行",
            "621428"=>"中国工商银行","625939"=>"中国工商银行","621434"=>"中国工商银行","625987"=>"中国工商银行","621761"=>"中国工商银行",
            "621749"=>"中国工商银行","620184"=>"中国工商银行","621300"=>"中国工商银行","621378"=>"中国工商银行","625114"=>"中国工商银行",
            "622159"=>"中国工商银行","621720"=>"中国工商银行","625021"=>"中国工商银行","625022"=>"中国工商银行","621379"=>"中国工商银行",
            "620114"=>"中国工商银行","620146"=>"中国工商银行","622889"=>"中国工商银行","625900"=>"中国工商银行","622949"=>"中国工商银行",
            "625915"=>"中国工商银行","625916"=>"中国工商银行","620030"=>"中国工商银行","620050"=>"中国工商银行","622944"=>"中国工商银行",
            "625115"=>"中国工商银行","620101"=>"中国工商银行","623335"=>"中国工商银行","622171"=>"中国工商银行","621240"=>"中国工商银行",
            "621724"=>"中国工商银行","621762"=>"中国工商银行","625918"=>"中国工商银行","621371"=>"中国工商银行","620143"=>"中国工商银行",
            "620149"=>"中国工商银行","621414"=>"中国工商银行","625914"=>"中国工商银行","621375"=>"中国工商银行","620187"=>"中国工商银行",
            "621433"=>"中国工商银行","625986"=>"中国工商银行","621370"=>"中国工商银行","625925"=>"中国工商银行","622926"=>"中国工商银行",
            "622927"=>"中国工商银行","622928"=>"中国工商银行","622929"=>"中国工商银行","622930"=>"中国工商银行","622931"=>"中国工商银行",
            "621733"=>"中国工商银行","621732"=>"中国工商银行","620124"=>"中国工商银行","620183"=>"中国工商银行","620561"=>"中国工商银行",
            "625116"=>"中国工商银行","622227"=>"中国工商银行","621372"=>"中国工商银行","621464"=>"中国工商银行","625942"=>"中国工商银行",
            "622158"=>"中国工商银行","625917"=>"中国工商银行","621765"=>"中国工商银行","620094"=>"中国工商银行","620186"=>"中国工商银行",
            "621719"=>"中国工商银行","621750"=>"中国工商银行","621377"=>"中国工商银行","620148"=>"中国工商银行","620185"=>"中国工商银行",
            "621374"=>"中国工商银行","621731"=>"中国工商银行","621781"=>"中国工商银行","552599"=>"中国农业银行","623206"=>"中国农业银行",
            "621671"=>"中国农业银行","620059"=>"中国农业银行","403361"=>"中国农业银行","404117"=>"中国农业银行","404118"=>"中国农业银行",
            "404119"=>"中国农业银行","404120"=>"中国农业银行","404121"=>"中国农业银行","463758"=>"中国农业银行","514027"=>"中国农业银行",
            "519412"=>"中国农业银行","519413"=>"中国农业银行","520082"=>"中国农业银行","520083"=>"中国农业银行","558730"=>"中国农业银行",
            "621282"=>"中国农业银行","621336"=>"中国农业银行","621619"=>"中国农业银行","622821"=>"中国农业银行","622822"=>"中国农业银行",
            "622823"=>"中国农业银行","622824"=>"中国农业银行","622825"=>"中国农业银行","622826"=>"中国农业银行","622827"=>"中国农业银行",
            "622828"=>"中国农业银行","622836"=>"中国农业银行","622837"=>"中国农业银行","622840"=>"中国农业银行","622841"=>"中国农业银行",
            "622843"=>"中国农业银行","622844"=>"中国农业银行","622845"=>"中国农业银行","622846"=>"中国农业银行","622847"=>"中国农业银行",
            "622848"=>"中国农业银行","622849"=>"中国农业银行","623018"=>"中国农业银行","625996"=>"中国农业银行","625997"=>"中国农业银行",
            "625998"=>"中国农业银行","628268"=>"中国农业银行","625826"=>"中国农业银行","625827"=>"中国农业银行","548478"=>"中国农业银行",
            "544243"=>"中国农业银行","622820"=>"中国农业银行","622830"=>"中国农业银行","622838"=>"中国农业银行","625336"=>"中国农业银行",
            "628269"=>"中国农业银行","620501"=>"中国农业银行","621660"=>"中国银行","621661"=>"中国银行","621662"=>"中国银行","621663"=>"中国银行",
            "621665"=>"中国银行","621667"=>"中国银行","621668"=>"中国银行","621669"=>"中国银行","621666"=>"中国银行","625908"=>"中国银行",
            "625910"=>"中国银行","625909"=>"中国银行","356833"=>"中国银行","356835"=>"中国银行","409665"=>"中国银行","409666"=>"中国银行",
            "409668"=>"中国银行","409669"=>"中国银行","409670"=>"中国银行","409671"=>"中国银行","409672"=>"中国银行","456351"=>"中国银行",
            "512315"=>"中国银行","512316"=>"中国银行","512411"=>"中国银行","512412"=>"中国银行","514957"=>"中国银行","409667"=>"中国银行",
            "518378"=>"中国银行","518379"=>"中国银行","518474"=>"中国银行","518475"=>"中国银行","518476"=>"中国银行","438088"=>"中国银行",
            "524865"=>"中国银行","525745"=>"中国银行","525746"=>"中国银行","547766"=>"中国银行","552742"=>"中国银行","553131"=>"中国银行",
            "558868"=>"中国银行","514958"=>"中国银行","622752"=>"中国银行","622753"=>"中国银行","622755"=>"中国银行","524864"=>"中国银行",
            "622757"=>"中国银行","622758"=>"中国银行","622759"=>"中国银行","622760"=>"中国银行","622761"=>"中国银行","622762"=>"中国银行",
            "622763"=>"中国银行","601382"=>"中国银行","622756"=>"中国银行","628388"=>"中国银行","621256"=>"中国银行","621212"=>"中国银行",
            "620514"=>"中国银行","622754"=>"中国银行","622764"=>"中国银行","518377"=>"中国银行","622765"=>"中国银行","622788"=>"中国银行",
            "621283"=>"中国银行","620061"=>"中国银行","621725"=>"中国银行","620040"=>"中国银行","558869"=>"中国银行","621330"=>"中国银行",
            "621331"=>"中国银行","621332"=>"中国银行","621333"=>"中国银行","621297"=>"中国银行","377677"=>"中国银行","621568"=>"中国银行",
            "621569"=>"中国银行","625905"=>"中国银行","625906"=>"中国银行","625907"=>"中国银行","628313"=>"中国银行","625333"=>"中国银行",
            "628312"=>"中国银行","623208"=>"中国银行","621620"=>"中国银行","621756"=>"中国银行","621757"=>"中国银行","621758"=>"中国银行",
            "621759"=>"中国银行","621785"=>"中国银行","621786"=>"中国银行","621787"=>"中国银行","621788"=>"中国银行","621789"=>"中国银行",
            "621790"=>"中国银行","621672"=>"中国银行","625337"=>"中国银行","625338"=>"中国银行","625568"=>"中国银行","620025"=>"中国银行",
            "620026"=>"中国银行","621293"=>"中国银行","621294"=>"中国银行","621342"=>"中国银行","621343"=>"中国银行","621364"=>"中国银行",
            "621394"=>"中国银行","621648"=>"中国银行","621248"=>"中国银行","621249"=>"中国银行","622750"=>"中国银行","622751"=>"中国银行",
            "622771"=>"中国银行","622772"=>"中国银行","622770"=>"中国银行","625145"=>"中国银行","620531"=>"中国银行","620210"=>"中国银行",
            "620211"=>"中国银行","622479"=>"中国银行","622480"=>"中国银行","622273"=>"中国银行","622274"=>"中国银行","620019"=>"中国银行",
            "620035"=>"中国银行","621231"=>"中国银行","621638"=>"中国银行","621334"=>"中国银行","625140"=>"中国银行","621395"=>"中国银行",
            "622725"=>"中国建设银行","622728"=>"中国建设银行","621284"=>"中国建设银行","421349"=>"中国建设银行","434061"=>"中国建设银行",
            "434062"=>"中国建设银行","436728"=>"中国建设银行","436742"=>"中国建设银行","453242"=>"中国建设银行","491031"=>"中国建设银行",
            "524094"=>"中国建设银行","526410"=>"中国建设银行","544033"=>"中国建设银行","552245"=>"中国建设银行","589970"=>"中国建设银行",
            "620060"=>"中国建设银行","621080"=>"中国建设银行","621081"=>"中国建设银行","621466"=>"中国建设银行","621467"=>"中国建设银行",
            "621488"=>"中国建设银行","621499"=>"中国建设银行","621598"=>"中国建设银行","621621"=>"中国建设银行","621700"=>"中国建设银行",
            "622280"=>"中国建设银行","622700"=>"中国建设银行","622707"=>"中国建设银行","622966"=>"中国建设银行","622988"=>"中国建设银行",
            "625955"=>"中国建设银行","625956"=>"中国建设银行","553242"=>"中国建设银行","621082"=>"中国建设银行","621673"=>"中国建设银行",
            "623211"=>"中国建设银行","356896"=>"中国建设银行","356899"=>"中国建设银行","356895"=>"中国建设银行","436718"=>"中国建设银行",
            "436738"=>"中国建设银行","436745"=>"中国建设银行","436748"=>"中国建设银行","489592"=>"中国建设银行","531693"=>"中国建设银行",
            "532450"=>"中国建设银行","532458"=>"中国建设银行","544887"=>"中国建设银行","552801"=>"中国建设银行","557080"=>"中国建设银行",
            "558895"=>"中国建设银行","559051"=>"中国建设银行","622166"=>"中国建设银行","622168"=>"中国建设银行","622708"=>"中国建设银行",
            "625964"=>"中国建设银行","625965"=>"中国建设银行","625966"=>"中国建设银行","628266"=>"中国建设银行","628366"=>"中国建设银行",
            "625362"=>"中国建设银行","625363"=>"中国建设银行","628316"=>"中国建设银行","628317"=>"中国建设银行","620021"=>"交通银行","620521"=>"交通银行",
            "405512"=>"交通银行","434910"=>"交通银行","458123"=>"交通银行","458124"=>"交通银行","520169"=>"交通银行","522964"=>"交通银行",
            "552853"=>"交通银行","601428"=>"交通银行","622250"=>"交通银行","622251"=>"交通银行","521899"=>"交通银行","622254"=>"交通银行",
            "622255"=>"交通银行","622256"=>"交通银行","622257"=>"交通银行","622258"=>"交通银行","622259"=>"交通银行","622253"=>"交通银行",
            "622261"=>"交通银行","622284"=>"交通银行","622656"=>"交通银行","628216"=>"交通银行","622252"=>"交通银行","622260"=>"交通银行",
            "955590"=>"交通银行","955591"=>"交通银行","955592"=>"交通银行","955593"=>"交通银行","628218"=>"交通银行","622262"=>"交通银行",
            "621069"=>"交通银行","620013"=>"交通银行","625028"=>"交通银行","625029"=>"交通银行","621436"=>"交通银行","621002"=>"交通银行",
            "621335"=>"交通银行","433670"=>"中信银行","433680"=>"中信银行","442729"=>"中信银行","442730"=>"中信银行","620082"=>"中信银行",
            "622690"=>"中信银行","622691"=>"中信银行","622692"=>"中信银行","622696"=>"中信银行","622698"=>"中信银行","622998"=>"中信银行",
            "622999"=>"中信银行","433671"=>"中信银行","968807"=>"中信银行","968808"=>"中信银行","968809"=>"中信银行","621771"=>"中信银行",
            "621767"=>"中信银行","621768"=>"中信银行","621770"=>"中信银行","621772"=>"中信银行","621773"=>"中信银行","620527"=>"中信银行",
            "356837"=>"光大银行","356838"=>"光大银行","486497"=>"光大银行","622660"=>"光大银行","622662"=>"光大银行","622663"=>"光大银行",
            "622664"=>"光大银行","622665"=>"光大银行","622666"=>"光大银行","622667"=>"光大银行","622669"=>"光大银行","622670"=>"光大银行",
            "622671"=>"光大银行","622672"=>"光大银行","622668"=>"光大银行","622661"=>"光大银行","622674"=>"光大银行","622673"=>"光大银行",
            "620518"=>"光大银行","621489"=>"光大银行","621492"=>"光大银行","620535"=>"光大银行","623156"=>"光大银行","621490"=>"光大银行",
            "621491"=>"光大银行","620085"=>"光大银行","623155"=>"光大银行","623157"=>"光大银行","623158"=>"光大银行","623159"=>"光大银行",
            "999999"=>"华夏银行","621222"=>"华夏银行","623020"=>"华夏银行","623021"=>"华夏银行","623022"=>"华夏银行","623023"=>"华夏银行",
            "622630"=>"华夏银行","622631"=>"华夏银行","622632"=>"华夏银行","622633"=>"华夏银行","622615"=>"民生银行","622616"=>"民生银行",
            "622618"=>"民生银行","622622"=>"民生银行","622617"=>"民生银行","622619"=>"民生银行","415599"=>"民生银行","421393"=>"民生银行",
            "421865"=>"民生银行","427570"=>"民生银行","427571"=>"民生银行","472067"=>"民生银行","472068"=>"民生银行","622620"=>"民生银行",
            "621691"=>"民生银行","545392"=>"民生银行","545393"=>"民生银行","545431"=>"民生银行","545447"=>"民生银行","356859"=>"民生银行",
            "356857"=>"民生银行","407405"=>"民生银行","421869"=>"民生银行","421870"=>"民生银行","421871"=>"民生银行","512466"=>"民生银行",
            "356856"=>"民生银行","528948"=>"民生银行","552288"=>"民生银行","622600"=>"民生银行","622601"=>"民生银行","622602"=>"民生银行",
            "517636"=>"民生银行","622621"=>"民生银行","628258"=>"民生银行","556610"=>"民生银行","622603"=>"民生银行","464580"=>"民生银行",
            "464581"=>"民生银行","523952"=>"民生银行","545217"=>"民生银行","553161"=>"民生银行","356858"=>"民生银行","622623"=>"民生银行",
            "625911"=>"民生银行","377152"=>"民生银行","377153"=>"民生银行","377158"=>"民生银行","377155"=>"民生银行","625912"=>"民生银行",
            "625913"=>"民生银行","406365"=>"广发银行","406366"=>"广发银行","428911"=>"广发银行","436768"=>"广发银行","436769"=>"广发银行",
            "487013"=>"广发银行","491032"=>"广发银行","491034"=>"广发银行","491035"=>"广发银行","491036"=>"广发银行","491037"=>"广发银行",
            "491038"=>"广发银行","518364"=>"广发银行","520152"=>"广发银行","520382"=>"广发银行","548844"=>"广发银行","552794"=>"广发银行",
            "622555"=>"广发银行","622556"=>"广发银行","622557"=>"广发银行","622558"=>"广发银行","622559"=>"广发银行","622560"=>"广发银行",
            "622568"=>"广发银行","528931"=>"广发银行","558894"=>"广发银行","625072"=>"广发银行","625071"=>"广发银行","628260"=>"广发银行",
            "628259"=>"广发银行","621462"=>"广发银行","625805"=>"广发银行","625806"=>"广发银行","625807"=>"广发银行","625808"=>"广发银行",
            "625809"=>"广发银行","625810"=>"广发银行","685800"=>"广发银行","620037"=>"广发银行","623506"=>"广发银行","412963"=>"平安银行",
            "415752"=>"平安银行","415753"=>"平安银行","622535"=>"平安银行","622536"=>"平安银行","622538"=>"平安银行","622539"=>"平安银行",
            "998800"=>"平安银行","412962"=>"平安银行","622983"=>"平安银行","620010"=>"平安银行","356885"=>"招商银行","356886"=>"招商银行",
            "356887"=>"招商银行","356888"=>"招商银行","356890"=>"招商银行","402658"=>"招商银行","410062"=>"招商银行","439188"=>"招商银行",
            "439227"=>"招商银行","468203"=>"招商银行","479228"=>"招商银行","479229"=>"招商银行","512425"=>"招商银行","521302"=>"招商银行",
            "524011"=>"招商银行","356889"=>"招商银行","545620"=>"招商银行","545621"=>"招商银行","545947"=>"招商银行","545948"=>"招商银行",
            "552534"=>"招商银行","552587"=>"招商银行","622575"=>"招商银行","622576"=>"招商银行","622577"=>"招商银行","622579"=>"招商银行",
            "622580"=>"招商银行","545619"=>"招商银行","622581"=>"招商银行","622582"=>"招商银行","622588"=>"招商银行","622598"=>"招商银行",
            "622609"=>"招商银行","690755"=>"招商银行","545623"=>"招商银行","621286"=>"招商银行","620520"=>"招商银行","621483"=>"招商银行",
            "621485"=>"招商银行","621486"=>"招商银行","628290"=>"招商银行","622578"=>"招商银行","370285"=>"招商银行","370286"=>"招商银行",
            "370287"=>"招商银行","370289"=>"招商银行","439225"=>"招商银行","518710"=>"招商银行","518718"=>"招商银行","628362"=>"招商银行",
            "439226"=>"招商银行","628262"=>"招商银行","625802"=>"招商银行","625803"=>"招商银行","621299"=>"招商银行","966666"=>"兴业银行",
            "622909"=>"兴业银行","622908"=>"兴业银行","438588"=>"兴业银行","438589"=>"兴业银行","461982"=>"兴业银行","486493"=>"兴业银行",
            "486494"=>"兴业银行","486861"=>"兴业银行","523036"=>"兴业银行","451289"=>"兴业银行","527414"=>"兴业银行","528057"=>"兴业银行",
            "622901"=>"兴业银行","622922"=>"兴业银行","628212"=>"兴业银行","451290"=>"兴业银行","524070"=>"兴业银行","625084"=>"兴业银行",
            "625085"=>"兴业银行","625086"=>"兴业银行","625087"=>"兴业银行","548738"=>"兴业银行","549633"=>"兴业银行","552398"=>"兴业银行",
            "625082"=>"兴业银行","625083"=>"兴业银行","625960"=>"兴业银行","625961"=>"兴业银行","625962"=>"兴业银行","625963"=>"兴业银行",
            "623078"=>"恒丰银行","622384"=>"恒丰银行","940034"=>"恒丰银行","940008"=>"齐鲁银行","622379"=>"齐鲁银行","622391"=>"潍坊银行",
            "940072"=>"潍坊银行","621019"=>"浙商银行","621268"=>"渤海银行","622884"=>"渤海银行","621453"=>"渤海银行","622684"=>"渤海银行",
            "621062"=>"花旗银行","621063"=>"花旗银行","622933"=>"东亚银行","622938"=>"东亚银行","623031"=>"东亚银行","622942"=>"渣打银行",
            "622994"=>"渣打银行","621016"=>"星展银行","621015"=>"星展银行","622950"=>"恒生银行","622951"=>"恒生银行","621060"=>"友利银行",
            "621072"=>"新韩银行","621201"=>"韩亚银行","621077"=>"华侨银行","621298"=>"永亨银行","621213"=>"南洋商业银行","621289"=>"南洋商业银行",
            "621290"=>"南洋商业银行","621291"=>"南洋商业银行","621292"=>"南洋商业银行","621245"=>"兴业银行","621328"=>"大华银行","621277"=>"大新银行",
            "623183"=>"上海银行","623185"=>"上海银行","621005"=>"上海银行","622172"=>"上海银行","622985"=>"上海银行","622987"=>"上海银行",
            "622267"=>"上海银行","622278"=>"上海银行","622279"=>"上海银行","622468"=>"上海银行","622892"=>"上海银行","940021"=>"上海银行",
            "621050"=>"上海银行","620522"=>"上海银行","356827"=>"上海银行","356828"=>"上海银行","356830"=>"上海银行","402673"=>"上海银行",
            "402674"=>"上海银行","438600"=>"上海银行","486466"=>"上海银行","519498"=>"上海银行","520131"=>"上海银行","524031"=>"上海银行",
            "548838"=>"上海银行","622148"=>"上海银行","622149"=>"上海银行","622268"=>"上海银行","356829"=>"上海银行","622300"=>"上海银行",
            "628230"=>"上海银行","622269"=>"上海银行","625099"=>"上海银行","625953"=>"上海银行","625350"=>"上海银行","625351"=>"上海银行",
            "625352"=>"上海银行","519961"=>"上海银行","625839"=>"上海银行","622393"=>"厦门银行","940023"=>"厦门银行","623019"=>"厦门银行",
            "621600"=>"厦门银行","421317"=>"北京银行","602969"=>"北京银行","621030"=>"北京银行","621420"=>"北京银行","621468"=>"北京银行",
            "623111"=>"北京银行","422160"=>"北京银行","422161"=>"北京银行","622388"=>"福建海峡银行","621267"=>"福建海峡银行","620043"=>"福建海峡银行",
            "623063"=>"福建海峡银行","622865"=>"吉林银行","940012"=>"吉林银行","623131"=>"吉林银行","622178"=>"吉林银行","622179"=>"吉林银行",
            "628358"=>"吉林银行","621279"=>"宁波银行","622281"=>"宁波银行","622316"=>"宁波银行","940022"=>"宁波银行","621418"=>"宁波银行",
            "512431"=>"宁波银行","520194"=>"宁波银行","621626"=>"平安银行","623058"=>"平安银行","602907"=>"平安银行","622986"=>"平安银行",
            "622989"=>"平安银行","622298"=>"平安银行","622338"=>"焦作市商业银行","940032"=>"焦作市商业银行","623205"=>"焦作市商业银行",
            "621977"=>"温州银行","603445"=>"广州银行","622467"=>"广州银行","940016"=>"广州银行","621463"=>"广州银行","990027"=>"汉口银行",
            "622325"=>"汉口银行","623029"=>"汉口银行","623105"=>"汉口银行","622475"=>"龙江银行","621244"=>"盛京银行","623081"=>"盛京银行",
            "623108"=>"盛京银行","566666"=>"盛京银行","622455"=>"盛京银行","940039"=>"盛京银行","622466"=>"盛京银行","628285"=>"盛京银行",
            "622420"=>"洛阳银行","940041"=>"洛阳银行","623118"=>"洛阳银行","603708"=>"大连银行","622993"=>"大连银行","623070"=>"大连银行",
            "623069"=>"大连银行","623172"=>"大连银行","623173"=>"大连银行","622383"=>"大连银行","622385"=>"大连银行","628299"=>"大连银行",
            "622498"=>"河北银行","622499"=>"河北银行","940046"=>"河北银行","623000"=>"河北银行","628242"=>"南京银行","622595"=>"南京银行",
            "621259"=>"南京银行","622596"=>"南京银行","940051"=>"金华银行","628204"=>"金华银行","622449"=>"金华银行","623067"=>"金华银行",
            "622450"=>"金华银行","621751"=>"乌鲁木齐市商业银行","628278"=>"乌鲁木齐市商业银行","625502"=>"乌鲁木齐市商业银行","625503"=>"乌鲁木齐市商业银行",
            "625135"=>"乌鲁木齐市商业银行","622476"=>"乌鲁木齐市商业银行","621754"=>"乌鲁木齐市商业银行","622143"=>"乌鲁木齐市商业银行",
            "940001"=>"乌鲁木齐市商业银行","622486"=>"绍兴银行","603602"=>"绍兴银行","623026"=>"绍兴银行","623086"=>"绍兴银行","628291"=>"绍兴银行",
            "623007"=>"临商银行","628205"=>"天津银行","622421"=>"郑州银行","940056"=>"郑州银行","628214"=>"宁夏银行","625529"=>"宁夏银行",
            "622428"=>"宁夏银行","621529"=>"宁夏银行","622429"=>"宁夏银行","621417"=>"宁夏银行","623089"=>"宁夏银行","623200"=>"宁夏银行",
            "622363"=>"珠海华润银行","940048"=>"珠海华润银行","621455"=>"珠海华润银行","940057"=>"齐商银行","622311"=>"齐商银行","623119"=>"齐商银行",
            "622990"=>"锦州银行","940003"=>"锦州银行","622877"=>"徽商银行","622879"=>"徽商银行","621775"=>"徽商银行","623203"=>"徽商银行",
            "603601"=>"徽商银行","622137"=>"徽商银行","622327"=>"徽商银行","622340"=>"徽商银行","622366"=>"徽商银行","622134"=>"重庆银行",
            "940018"=>"重庆银行","623016"=>"重庆银行","623096"=>"重庆银行","940049"=>"哈尔滨银行","622425"=>"哈尔滨银行","621577"=>"哈尔滨银行",
            "622133"=>"贵阳银行","621735"=>"贵阳银行","622170"=>"贵阳银行","622136"=>"西安银行","622981"=>"西安银行","622139"=>"兰州银行",
            "940040"=>"兰州银行","621242"=>"兰州银行","621538"=>"兰州银行","621496"=>"兰州银行","623129"=>"兰州银行","621216"=>"晋商银行",
            "622465"=>"晋商银行","940031"=>"晋商银行","621252"=>"青岛银行","622146"=>"青岛银行","940061"=>"青岛银行","621419"=>"青岛银行",
            "623170"=>"青岛银行","622440"=>"吉林银行","940047"=>"吉林银行","622162"=>"九江银行","623077"=>"日照银行","622310"=>"青海银行",
            "940068"=>"青海银行","622321"=>"台州银行","625001"=>"台州银行","622427"=>"台州银行","940069"=>"台州银行","623039"=>"台州银行",
            "628273"=>"台州银行","694301"=>"长沙银行","940071"=>"长沙银行","622368"=>"长沙银行","621446"=>"长沙银行","625901"=>"长沙银行",
            "622898"=>"长沙银行","622900"=>"长沙银行","628281"=>"长沙银行","628282"=>"长沙银行","628283"=>"长沙银行","620519"=>"长沙银行",
            "621739"=>"长沙银行","622967"=>"赣州银行","940073"=>"赣州银行","622370"=>"泉州银行","683970"=>"泉州银行","940074"=>"泉州银行",
            "621437"=>"泉州银行","628319"=>"泉州银行","622400"=>"营口银行","623177"=>"营口银行","622126"=>"阜新银行","623166"=>"阜新银行",
            "622132"=>"嘉兴银行","621340"=>"廊坊银行","621341"=>"廊坊银行","622140"=>"廊坊银行","623073"=>"廊坊银行","622147"=>"内蒙古银行",
            "621633"=>"内蒙古银行","621266"=>"沧州银行","621422"=>"沧州银行","622336"=>"包商银行","622165"=>"包商银行","628295"=>"包商银行",
            "625950"=>"包商银行","621760"=>"包商银行","623102"=>"威海市商业银行","622342"=>"攀枝花市商业银行","623048"=>"攀枝花市商业银行",
            "622367"=>"绵阳市商业银行","622448"=>"广东南粤银行","622982"=>"张家口市商业银行","621413"=>"张家口市商业银行","621037"=>"龙江银行",
            "621097"=>"龙江银行","621588"=>"龙江银行","623032"=>"龙江银行","622644"=>"龙江银行","623518"=>"龙江银行","622860"=>"龙江银行",
            "622292"=>"柳州银行","622291"=>"柳州银行","621412"=>"柳州银行","622880"=>"柳州银行","622881"=>"柳州银行","620118"=>"柳州银行",
            "623072"=>"南充市商业银行","622897"=>"南充市商业银行","628279"=>"莱商银行","621403"=>"莱商银行","622561"=>"德阳银行","622562"=>"德阳银行",
            "622563"=>"德阳银行","622777"=>"曲靖市商业银行","621497"=>"曲靖市商业银行","622868"=>"温州银行","622899"=>"温州银行","628255"=>"温州银行",
            "625988"=>"温州银行","622566"=>"汉口银行","622567"=>"汉口银行","622625"=>"汉口银行","622626"=>"汉口银行","625946"=>"汉口银行",
            "628200"=>"汉口银行","621076"=>"江苏银行","504923"=>"江苏银行","622173"=>"江苏银行","622422"=>"江苏银行","622447"=>"江苏银行",
            "622131"=>"江苏银行","940076"=>"江苏银行","621579"=>"江苏银行","622876"=>"江苏银行","622873"=>"江苏银行","531659"=>"平安银行",
            "622157"=>"平安银行","435744"=>"平安银行","435745"=>"平安银行","483536"=>"平安银行","622525"=>"平安银行","622526"=>"平安银行",
            "998801"=>"平安银行","998802"=>"平安银行","528020"=>"平安银行","622155"=>"平安银行","622156"=>"平安银行","526855"=>"平安银行",
            "356869"=>"平安银行","356868"=>"平安银行","625360"=>"平安银行","625361"=>"平安银行","628296"=>"平安银行","625825"=>"平安银行",
            "625823"=>"平安银行","623060"=>"承德银行","622937"=>"德州银行","623101"=>"德州银行","622960"=>"邯郸市商业银行","623523"=>"邯郸市商业银行",
            "628210"=>"江苏银行","622283"=>"江苏银行","625902"=>"江苏银行","622980"=>"玉溪市商业银行","623135"=>"玉溪市商业银行","621726"=>"浙江民泰商业银行",
            "621088"=>"浙江民泰商业银行","620517"=>"浙江民泰商业银行","622740"=>"浙江民泰商业银行","625036"=>"浙江民泰商业银行","622972"=>"泰安市商业银行",
            "623196"=>"泰安市商业银行","621028"=>"浙江稠州商业银行","623083"=>"浙江稠州商业银行","628250"=>"浙江稠州商业银行","622973"=>"乌海银行",
            "623153"=>"乌海银行","623121"=>"自贡市商业银行","621070"=>"自贡市商业银行","622977"=>"龙江银行","621200"=>"济宁银行","623116"=>"济宁银行",
            "621296"=>"长安银行","621448"=>"长安银行","622945"=>"三峡银行","621755"=>"三峡银行","621029"=>"昆仑银行","621766"=>"昆仑银行",
            "623139"=>"昆仑银行","621071"=>"平顶山银行","623152"=>"平顶山银行","628339"=>"平顶山银行","621345"=>"宁波东海银行","621238"=>"邢台银行",
            "621223"=>"晋中银行","621780"=>"晋中银行","621239"=>"衡水银行","623068"=>"衡水银行","621366"=>"华融湘江银行","621388"=>"华融湘江银行",
            "621217"=>"湖北银行","622959"=>"湖北银行","621270"=>"湖北银行","622396"=>"湖北银行","622511"=>"湖北银行","623076"=>"湖北银行",
            "621469"=>"广东华兴银行","621625"=>"广东华兴银行","623688"=>"广东华兴银行","623113"=>"广东华兴银行","621655"=>"宁波通商银行",
            "623087"=>"枣庄银行","627069"=>"平安银行","627068"=>"平安银行","627066"=>"平安银行","627067"=>"平安银行","622955"=>"盛京银行",
            "622462"=>"农村商业银行","628272"=>"农村商业银行","625101"=>"农村商业银行","622323"=>"农村商业银行","623071"=>"农村商业银行",
            "603694"=>"农村商业银行","622128"=>"农村商业银行","622129"=>"农村商业银行","623035"=>"农村商业银行","623186"=>"农村商业银行",
            "909810"=>"农村商业银行","940035"=>"农村商业银行","621522"=>"农村商业银行","622439"=>"农村商业银行","622271"=>"农村商业银行",
            "940037"=>"农村商业银行","940038"=>"农村商业银行","985262"=>"农村商业银行","622322"=>"农村商业银行","628381"=>"农村商业银行",
            "622481"=>"农村商业银行","622341"=>"农村商业银行","940058"=>"农村商业银行","623115"=>"农村商业银行","622867"=>"农村商业银行",
            "622885"=>"农村商业银行","940020"=>"农村商业银行","621258"=>"农村商业银行","621465"=>"农村商业银行","621528"=>"农村商业银行",
            "622328"=>"农村商业银行","940062"=>"农村商业银行","625288"=>"农村商业银行","623038"=>"农村商业银行","625888"=>"农村商业银行",
            "622332"=>"农村商业银行","940063"=>"农村商业银行","623123"=>"农村商业银行","622138"=>"农村商业银行","621066"=>"农村商业银行",
            "621560"=>"农村商业银行","621068"=>"农村商业银行","620088"=>"农村商业银行","621067"=>"农村商业银行","622531"=>"农村商业银行",
            "622329"=>"农村商业银行","623103"=>"农村商业银行","622339"=>"农村合作银行","620500"=>"农村合作银行","621024"=>"农村合作银行",
            "622289"=>"农村合作银行","622389"=>"农村合作银行","628300"=>"农村合作银行","622343"=>"农村信用合作社","625516"=>"农村商业银行",
            "621516"=>"农村商业银行","622345"=>"农村商业银行","622855"=>"苏州银行","621461"=>"苏州银行","623521"=>"苏州银行","622859"=>"农村商业银行",
            "622869"=>"农村商业银行","623075"=>"农村商业银行","622882"=>"农村信用合作社","622893"=>"贵州省农村信用社联合社","621590"=>"贵州省农村信用社联合社",
            "622895"=>"农村商业银行","623125"=>"农村商业银行","622506"=>"陕西省农村信用社联合社","621566"=>"陕西省农村信用社联合社",
            "623027"=>"陕西省农村信用社联合社","623028"=>"陕西省农村信用社联合社","628323"=>"陕西省农村信用社联合社","622992"=>"广西农村信用社",
            "623133"=>"广西农村信用社","622947"=>"农村商业银行","621561"=>"农村商业银行","623095"=>"农村商业银行","621073"=>"农村商业银行",
            "623109"=>"农村商业银行","621361"=>"农村商业银行","623033"=>"农村商业银行","623207"=>"农村商业银行","622891"=>"农村商业银行",
            "621363"=>"农村商业银行","623189"=>"农村商业银行","623510"=>"农村商业银行","622995"=>"村镇银行","621053"=>"村镇银行","621230"=>"村镇银行",
            "621229"=>"村镇银行","622218"=>"农村商业银行","628267"=>"农村商业银行","621392"=>"村镇银行","621481"=>"村镇银行","621310"=>"村镇银行",
            "621396"=>"村镇银行","622372"=>"东亚银行","622365"=>"东亚银行","622471"=>"东亚银行","622943"=>"东亚银行","622472"=>"东亚银行",
            "623318"=>"东亚银行","621411"=>"东亚银行","622371"=>"花旗银行","625091"=>"花旗银行","622293"=>"大新银行","622295"=>"大新银行",
            "622296"=>"大新银行","622297"=>"大新银行","622373"=>"大新银行","622375"=>"大新银行","622451"=>"大新银行","622294"=>"大新银行",
            "625940"=>"大新银行","622489"=>"大新银行","622871"=>"永亨银行","622958"=>"永亨银行","622963"=>"永亨银行","622957"=>"永亨银行",
            "622798"=>"永亨银行","625010"=>"永亨银行","622381"=>"中国建设银行","622675"=>"中国建设银行","622676"=>"中国建设银行","622677"=>"中国建设银行",
            "622382"=>"中国建设银行","621487"=>"中国建设银行","621083"=>"中国建设银行","622487"=>"星展银行","622490"=>"星展银行","622491"=>"星展银行",
            "622492"=>"星展银行","621744"=>"星展银行","621745"=>"星展银行","621746"=>"星展银行","621747"=>"星展银行","621034"=>"上海商业银行",
            "622386"=>"上海商业银行","622952"=>"上海商业银行","625107"=>"上海商业银行","622387"=>"永隆银行","622423"=>"永隆银行","622971"=>"永隆银行",
            "622970"=>"永隆银行","625062"=>"永隆银行","625063"=>"永隆银行","622360"=>"汇丰银行","622361"=>"汇丰银行","625034"=>"汇丰银行",
            "625096"=>"汇丰银行","625098"=>"汇丰银行","622406"=>"汇丰银行","622407"=>"汇丰银行","621442"=>"汇丰银行","621443"=>"汇丰银行",
            "625026"=>"恒生银行","625024"=>"恒生银行","622376"=>"恒生银行","622378"=>"恒生银行","622377"=>"恒生银行","625092"=>"恒生银行",
            "622409"=>"恒生银行","622410"=>"恒生银行","621440"=>"恒生银行","621441"=>"恒生银行","623106"=>"恒生银行","623107"=>"恒生银行",
            "622453"=>"中信嘉华银行","622456"=>"中信嘉华银行","622459"=>"中信嘉华银行","624303"=>"中信嘉华银行","623328"=>"中信嘉华银行",
            "622272"=>"创兴银行","622463"=>"创兴银行","621087"=>"创兴银行","625008"=>"创兴银行","625009"=>"创兴银行","621741"=>"中国银行",
            "623040"=>"中国银行","620202"=>"中国银行","620203"=>"中国银行","625136"=>"中国银行","621782"=>"中国银行","623309"=>"中国银行",
            "625046"=>"南洋商业银行","625044"=>"南洋商业银行","625058"=>"南洋商业银行","621743"=>"南洋商业银行","623041"=>"南洋商业银行",
            "620208"=>"南洋商业银行","620209"=>"南洋商业银行","621042"=>"南洋商业银行","621783"=>"南洋商业银行","623308"=>"南洋商业银行",
            "625048"=>"集友银行","625053"=>"集友银行","625060"=>"集友银行","621742"=>"集友银行","623042"=>"集友银行","620206"=>"集友银行",
            "620207"=>"集友银行","621043"=>"集友银行","621784"=>"集友银行","623310"=>"集友银行","621084"=>"中国建设银行","622948"=>"渣打银行",
            "621740"=>"渣打银行","622482"=>"渣打银行","622483"=>"渣打银行","622484"=>"渣打银行","620107"=>"中国建设银行","622433"=>"大华银行",
            "622861"=>"永亨银行","622932"=>"永亨银行","622862"=>"永亨银行","622775"=>"永亨银行","622785"=>"永亨银行","625017"=>"中国工商银行",
            "625018"=>"中国工商银行","625019"=>"中国工商银行","622346"=>"中国银行","622347"=>"中国银行","622348"=>"中国银行","622349"=>"南洋商业银行",
            "622350"=>"南洋商业银行","622352"=>"集友银行","622353"=>"集友银行","622355"=>"集友银行","621041"=>"中国银行","622351"=>"南洋商业银行",
            "376968"=>"中信银行","376969"=>"中信银行","400360"=>"中信银行","403391"=>"中信银行","403392"=>"中信银行","376966"=>"中信银行",
            "404158"=>"中信银行","404159"=>"中信银行","404171"=>"中信银行","404172"=>"中信银行","404173"=>"中信银行","404174"=>"中信银行",
            "404157"=>"中信银行","433667"=>"中信银行","433668"=>"中信银行","433669"=>"中信银行","514906"=>"中信银行","403393"=>"中信银行",
            "520108"=>"中信银行","433666"=>"中信银行","558916"=>"中信银行","622678"=>"中信银行","622679"=>"中信银行","622680"=>"中信银行",
            "622688"=>"中信银行","622689"=>"中信银行","628206"=>"中信银行","556617"=>"中信银行","628209"=>"中信银行","518212"=>"中信银行",
            "628208"=>"中信银行","356390"=>"中信银行","356391"=>"中信银行","356392"=>"中信银行","622916"=>"中信银行","622918"=>"中信银行",
            "622919"=>"中信银行","628370"=>"中信银行","628371"=>"中信银行","628372"=>"中信银行","622657"=>"光大银行","622685"=>"光大银行",
            "622659"=>"光大银行","622687"=>"光大银行","625978"=>"光大银行","625980"=>"光大银行","625981"=>"光大银行","625979"=>"光大银行",
            "356839"=>"光大银行","356840"=>"光大银行","406252"=>"光大银行","406254"=>"光大银行","425862"=>"光大银行","481699"=>"光大银行",
            "524090"=>"光大银行","543159"=>"光大银行","622161"=>"光大银行","622570"=>"光大银行","622650"=>"光大银行","622655"=>"光大银行",
            "622658"=>"光大银行","625975"=>"光大银行","625977"=>"光大银行","628201"=>"光大银行","628202"=>"光大银行","625976"=>"光大银行",
            "625339"=>"光大银行","622801"=>"光大银行","523959"=>"华夏银行","528709"=>"华夏银行","539867"=>"华夏银行","539868"=>"华夏银行",
            "622637"=>"华夏银行","622638"=>"华夏银行","628318"=>"华夏银行","528708"=>"华夏银行","622636"=>"华夏银行","625967"=>"华夏银行",
            "625968"=>"华夏银行","625969"=>"华夏银行","622265"=>"东亚银行","622266"=>"东亚银行","625972"=>"东亚银行","625973"=>"东亚银行",
            "625093"=>"南洋商业银行","625095"=>"南洋商业银行","522001"=>"北京银行","622163"=>"北京银行","622853"=>"北京银行","628203"=>"北京银行",
            "622851"=>"北京银行","622852"=>"北京银行","625903"=>"宁波银行","622282"=>"宁波银行","622318"=>"宁波银行","622778"=>"宁波银行",
            "628207"=>"宁波银行","628379"=>"齐鲁银行","625050"=>"广州银行","625836"=>"广州银行","628367"=>"广州银行","628333"=>"龙江银行",
            "622921"=>"河北银行","628321"=>"河北银行","625598"=>"河北银行","621777"=>"南京银行","628359"=>"临商银行","628270"=>"珠海华润银行",
            "628311"=>"齐商银行","628261"=>"锦州银行","628251"=>"徽商银行","622651"=>"徽商银行","625828"=>"徽商银行","625652"=>"徽商银行",
            "625700"=>"徽商银行","622613"=>"重庆银行","628220"=>"重庆银行","628224"=>"哈尔滨银行","625119"=>"哈尔滨银行","625577"=>"哈尔滨银行",
            "625952"=>"哈尔滨银行","621752"=>"哈尔滨银行","628213"=>"贵阳银行","628263"=>"兰州银行","628239"=>"青岛银行","628238"=>"九江银行",
            "628257"=>"日照银行","622817"=>"青海银行","628287"=>"青海银行","625959"=>"青海银行","628391"=>"潍坊银行","628233"=>"赣州银行",
            "628231"=>"富滇银行","628275"=>"浙江泰隆商业银行","622565"=>"浙江泰隆商业银行","622287"=>"浙江泰隆商业银行","622717"=>"浙江泰隆商业银行",
            "628252"=>"内蒙古银行","628306"=>"湖州银行","628227"=>"广西北部湾银行","623001"=>"广西北部湾银行","628234"=>"威海市商业银行",
            "621727"=>"广东南粤银行","623128"=>"广东南粤银行","628237"=>"广东南粤银行","628219"=>"桂林银行","621456"=>"桂林银行","621562"=>"桂林银行",
            "622270"=>"龙江银行","628368"=>"龙江银行","625588"=>"龙江银行","625090"=>"龙江银行","628293"=>"柳州银行","625080"=>"农村商业银行",
            "628235"=>"农村商业银行","628322"=>"农村商业银行","625088"=>"农村商业银行","628229"=>"承德银行","628397"=>"德州银行","622829"=>"农村商业银行",
            "625819"=>"农村商业银行","628301"=>"农村商业银行","622808"=>"农村商业银行","628308"=>"农村商业银行","623088"=>"农村商业银行",
            "628223"=>"上饶银行","621416"=>"上饶银行","622569"=>"农村商业银行","628369"=>"农村商业银行","628392"=>"江西省农村信用社联合社",
            "623092"=>"江西省农村信用社联合社","620528"=>"邢台银行","621748"=>"商丘市商业银行","628271"=>"商丘市商业银行","628328"=>"华融湘江银行",
            "623251"=>"中国建设银行","623165"=>"西安银行","628351"=>"玉溪市商业银行"
        ];
    }
}